package com.oceanread.cn.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oceanread.cn.entity.Projections;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ProjectionsMapper extends BaseMapper<Projections> {
    List<Projections> getall();

    Integer getnum();

    Integer getnumquery(@Param("key") String key, @Param("value") String value);

    List<Projections> findall(@Param("start") int start, @Param("end") int end);

    List<Projections> query(@Param("start") int start, @Param("end") int end, @Param("key") String key, @Param("value") String value);

    int insert(@Param("PrjCode") String PrjCode, @Param("Name") String Name,
               @Param("ShortName") String ShortName, @Param("Date") String Date,
               @Param("Lon") String Lon, @Param("Lat") String Lat, @Param("Type") String Type,
               @Param("CameraHight") String CameraHight,
               @Param("NumPipeline") String NumPipeline,
               @Param("LengthPipeline") String LengthPipeline,
               @Param("DepthPipeline") String DepthPipeline,
               @Param("NumDrillhole") String NumDrillhole,
               @Param("NumProfile") String NumProfile,
               @Param("UndertakingUnit") String UndertakingUnit
    );


    Integer update(@Param("SYSID") int SYSID,
                   @Param("PrjCode") String PrjCode,
                   @Param("Name") String Name,
                   @Param("ShortName") String ShortName,
                   @Param("Date") String Date,
                   @Param("Lon") String Lon,
                   @Param("Lat") String Lat,
                   @Param("Type") String Type,
                   @Param("CameraHight") String CameraHight,
                   @Param("NumPipeline") String NumPipeline,
                   @Param("LengthPipeline") String LengthPipeline,
                   @Param("DepthPipeline") String DepthPipeline,
                   @Param("NumDrillhole") String NumDrillhole,
                   @Param("NumProfile") String NumProfile,
                   @Param("UndertakingUnit") String UndertakingUnit
    );

    Integer delete(@Param("SYSID") int SYSID);
}
